--Execute as oe/oe
DROP  TABLE customer_profiles
/
CREATE TABLE customer_profiles (
   id  NUMBER,
   full_name    VARCHAR2(45),
   resume       CLOB DEFAULT EMPTY_CLOB(),
   picture      BLOB DEFAULT EMPTY_BLOB())
   LOB(picture) STORE AS BASICFILE
     (TABLESPACE lob_tbs1);
